﻿var ibmdb = require('ibm_db');
var connStr = "DATABASE=sample;HOSTNAME=10.10.3.12;UID=db2inst1;PWD=12345678;PORT=50000;PROTOCOL=TCPIP";

ibmdb.open(connStr, function (err,conn) {
  if (err) return console.log(err);
  
  conn.query("SELECT TOPNAME FROM ARADMIN.ITSM_UNIONQUERYVIEW WHERE CODE='20230228019'", function (err, data) {
    if (err) console.log(err);
    else console.log(data);

    conn.close(function () {
      console.log('done');
    });
  });
});
